TenderAccountApprovalReference

Entity Definition

Logical Name : TenderAccountApprovalReference
Physical Name : CO_RFC_TND_APVL

Repository of external account numbers against which an individual tender can be approved or rejected depending on the status of that account.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TenderTypeCode (FK)(PK) A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. TY_TND Code varchar(20) Tender(AS_TND)
AccountNumber (PK) The CUSTOMER's account number against which previous tender authorization is held. ID_ACNT_NMB Identity integer
TenderAuthorizationProviderID (FK) A unique system defined identifier for the Provider. ID_PRV Identity integer TenderAuthorizationProvider(PA_TND_AZN_PVR)
TenderAuthorizationPermissionFlag Flag that grants or revokes permission to accept this tender for this account. FL_PRMS Flag integer
TenderAuthorizationFollowUpActionCode A retailer defined code that indicates that follow up action may be required by the retailer after accepting or rejecting a customer tender. LU_ACTN_FLW_UP Code2 char(2)
CeilingLimitAmount The monetary amount up to which approval can be sought. UL_APVL_TND Money decimal(16,5)
TenderAuthorizationLastActionCode A retailer defined code that indicates the last action taken on this approval reference. Examples include an increase or decrease in the ceiling limit amount. LU_ACTN_LS Code2 char(2)
TenderIssuingBankID The bank or financial services organization that issued the credit or debit card. ID_BK_TND_ISSG Identity integer
CreateDateTimestamp The date and time this tender approval reference was created. TS_CRT_TND_APVL AuditDateTime datetime
LastUpdateDateTimestamp The date and time the tender approval reference was last modified. TS_UPDT_LS_APVL AuditDateTime datetime
LastApprovalGivenDateTimestamp The date and time this tender approval reference last approved a tender payment at the store. TS_APVL_TND_LS_GVN AuditDateTime datetime

Relationships

Parent Entity Verb Phrase Child Entity
TenderAuthorizationProvider provides TenderAccountApprovalReference
Tender is approved by TenderAccountApprovalReference
TenderAccountApprovalReference validates TenderLineItem

Logical Views containing TenderAccountApprovalReference

Logical View
Logical 02330 - Retail Transaction - Tender - Macro View
Logical 02336 - Retail Transaction - Tender - Authorization View
Logical 02339 - Retail Transaction - Tender - Account View